UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Oo9m2wP3wtBlbyRKKGbNV7sRiHTkYnQiqidP8Jwg20w='
WHERE
key_id = '8e097836e8a0b32af2be5e5cea33f2db0dc7874951e42a67d44791c21c27bcb3'
AND (
token = 'Oo9m2wP3wtBlbyRKKGbNV7sRiHTkYnQiqidP8Jwg20w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)