UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C53lMJifNYjhfDBDUEXtGeSIhBa0C9lw/a80G3Dj8bU='
WHERE
key_id = '0c7e40ca829b43dd4a957cab23c79fb57e0eff8b0fb0284cddc445dd95665382'
AND (
token = 'C53lMJifNYjhfDBDUEXtGeSIhBa0C9lw/a80G3Dj8bU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)