UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vCpEkAtQ9TQQT4LlR1gVNrXA+3FBieGChAK6LiRRevI='
WHERE
key_id = 'f19a49663e0cbed8da399e7d2963e278936276c2101b64d83933c101fccae8ec'
AND (
token = 'vCpEkAtQ9TQQT4LlR1gVNrXA+3FBieGChAK6LiRRevI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)