UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '20K23Pxaj0Z9lO6WchEGou/NFTr7ud76TZZ8ZlRQsnA='
WHERE
key_id = 'a9d581b9595c437abafb7fff5a6e1c7bfb5fa2b8f4024a0f7a5587e93764ba0a'
AND (
token = '20K23Pxaj0Z9lO6WchEGou/NFTr7ud76TZZ8ZlRQsnA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)