UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8MKIM2MyxLp67ic8DTBUbK9Cmlem3sIxXyxvTJayXyA='
WHERE
key_id = '0a2bb49afa5268895d0a0d9fd3d98e41c3c071a23d3e7555c726f87f5046f0e0'
AND (
token = '8MKIM2MyxLp67ic8DTBUbK9Cmlem3sIxXyxvTJayXyA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)