UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zkcPV4Luj1VwfwQvDWAJdOxfyBJj+iSpXevosE33u8w='
WHERE
key_id = '912f6f56024a38f6da9a1d102e2d363ea0682fb06e7390827b26d6ddc840bd83'
AND (
token = 'zkcPV4Luj1VwfwQvDWAJdOxfyBJj+iSpXevosE33u8w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)