UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'v6OPkcsk/o+vJK4MEzv62cv0kdVXrn4vgq1t4Jvd/7U='
WHERE
key_id = 'e1f662574a150ffa134b339dd1927a9a11585ca6f24397b81d1d7876a9fe5dca'
AND (
token = 'v6OPkcsk/o+vJK4MEzv62cv0kdVXrn4vgq1t4Jvd/7U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)