UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rpoX+L7AmOR3iVGS2wwzgx3CZtIa3Y9d5KXWnviFLCI='
WHERE
key_id = '716a673ff66c62bb7a2a27ef1c8e9f4650e20072b7cd0bc848281fe8b8af77dd'
AND (
token = 'rpoX+L7AmOR3iVGS2wwzgx3CZtIa3Y9d5KXWnviFLCI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)