UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lkPhqIb51K5ucAAt6L512so5jKRWvWwbczrCW5be5sE='
WHERE
key_id = '1cce0c324fecba332b50f7b46839484e7cf82d96379c6a7a1d3ac6376f07fcfb'
AND (
token = 'lkPhqIb51K5ucAAt6L512so5jKRWvWwbczrCW5be5sE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)