UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mjzXz7ozSVesq6ySPjIV6urhrowOSzUNo9FoXE4HlZw='
WHERE
key_id = 'ae7321a78fe3ef597fb61f626a13b91b92a0c2cf2467c15cdcdc74a332f3c4ba'
AND (
token = 'mjzXz7ozSVesq6ySPjIV6urhrowOSzUNo9FoXE4HlZw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)