UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'd3Kwuvq9iW1rB907/qIYinGCENVRI71amQQ8HU/O3mk='
WHERE
key_id = 'af8e4fb486c7ff6f7146d7633a314e156c5974af1f5dd44720014f043a6a1787'
AND (
token = 'd3Kwuvq9iW1rB907/qIYinGCENVRI71amQQ8HU/O3mk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)