UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1YGCNvmfdx46PeCLkoUVR9zKyVRo3zpRA5fdLQr+zD4='
WHERE
key_id = 'c502162d4fc744841900c0d1b9788b7bd451228b948c45813480a853bbed035c'
AND (
token = '1YGCNvmfdx46PeCLkoUVR9zKyVRo3zpRA5fdLQr+zD4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)