UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZBuPadVrigU/oSt4+aGi5bH+0lyrPAKyrU40yFdnREQ='
WHERE
key_id = '27f0e5f52dac9923a051e380cee1769aa27c00b8e53bbf74ebbbb2cc0a51880a'
AND (
token = 'ZBuPadVrigU/oSt4+aGi5bH+0lyrPAKyrU40yFdnREQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)