UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'M6cKngYkS4fuVpm7f3kcZlFU3o3jIYC5a9VLUsQcY3I='
WHERE
key_id = '807da7d218ffd1155bb2e4a29780b9eae3e5b992676cc4cb4e4967487c937270'
AND (
token = 'M6cKngYkS4fuVpm7f3kcZlFU3o3jIYC5a9VLUsQcY3I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)