UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vPpBG2iI9QavW8CDSnhATA6h0jfoRN5dddZ81uAApSw='
WHERE
key_id = '69c05578686ef9339ab1f1af674ef8e771203b63bcb475f9ed4d40db588e63ec'
AND (
token = 'vPpBG2iI9QavW8CDSnhATA6h0jfoRN5dddZ81uAApSw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)