UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cWAs2Ez6RCOV4B0sxEXCNkILHgmFGq9zqiE76Th54GU='
WHERE
key_id = '0e3c6bbe6157d6c24efe26aa5987681f626cac990d19a28a0ca9d22610aec9c3'
AND (
token = 'cWAs2Ez6RCOV4B0sxEXCNkILHgmFGq9zqiE76Th54GU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)