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