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