UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aShsb1YQpkTSkCHuh/rBrr3bbIyTG16moOuLI8u70vc='
WHERE
key_id = 'a05fc3797419698cfd6477c6875eba89939bb6878f24edeaa72db66129a2fde2'
AND (
token = 'aShsb1YQpkTSkCHuh/rBrr3bbIyTG16moOuLI8u70vc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)