UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pEH/PKZAP+1Zc+zm0jxx9Gu0qe+GPU9Y9tyxa6TQHp0='
WHERE
key_id = 'c7265807fcb047bb140ce2a2e7c5226ff44c9927633f068d5a46f3db62eba162'
AND (
token = 'pEH/PKZAP+1Zc+zm0jxx9Gu0qe+GPU9Y9tyxa6TQHp0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)