UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6CJH1ODis5L84FtI7VV6h2z77xKBeAxAW/rWNKseb8o='
WHERE
key_id = '77f0de68a5b7851405ac925c1d7a6f13edc44bb9a1ef5448b649a5901178b56e'
AND (
token = '6CJH1ODis5L84FtI7VV6h2z77xKBeAxAW/rWNKseb8o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)