UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BmduzV3USuL5sIlK6or9pNAA6e3xpb8Hy6p4PZi9igk='
WHERE
key_id = 'c0849b2965c4977d372788cf18e75a9fbec2507d626ba39636a5e22ef39da9df'
AND (
token = 'BmduzV3USuL5sIlK6or9pNAA6e3xpb8Hy6p4PZi9igk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)