UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NR1OzpvaUeKccihRF33bEi81JF/MhYryZ/4l7/F2wgk='
WHERE
key_id = '29c21afa80ce6a25ee11c1857c3ebb3797a4a5f2a848c4b73db40030b41b1903'
AND (
token = 'NR1OzpvaUeKccihRF33bEi81JF/MhYryZ/4l7/F2wgk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)