UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aBE/3UsVwTuIEgFsoxqmiGBDcqw+8KtFqd+rMKIeWrI='
WHERE
key_id = 'c3ad5049df2f25a88a96851bf980cd79cf78a58405442898d45c306afa1de564'
AND (
token = 'aBE/3UsVwTuIEgFsoxqmiGBDcqw+8KtFqd+rMKIeWrI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)