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