UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'M6GVNf2SVh8ec3DJZvIQ4pPtmofcY0MEExVg6nniZfs='
WHERE
key_id = 'b8175e0269795ba9f3d87296e7dca229adcd83409e5a9d49352c8680d0e0fb9c'
AND (
token = 'M6GVNf2SVh8ec3DJZvIQ4pPtmofcY0MEExVg6nniZfs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)