UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'v16pKjgmM7STZ39RUN5LRZ9gxFlTzrJU83k1SIKX33o='
WHERE
key_id = '9fcb6689304e0a11b94401b4d61bda4ef31b4f8d36644ca040842472f06aa4ec'
AND (
token = 'v16pKjgmM7STZ39RUN5LRZ9gxFlTzrJU83k1SIKX33o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)