UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W5LpRBaaXzHdAnA3cisRvp7srXFYCh+FtRDghFktgAc='
WHERE
key_id = '3ffe0b3a5142e995d8cc512a861f5a2a6b165677b2c5494a20dad8337bc022d1'
AND (
token = 'W5LpRBaaXzHdAnA3cisRvp7srXFYCh+FtRDghFktgAc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)