UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HC2NJBB9svfya6YM72H7I+feRItzU3V+oLTP8LONKRU='
WHERE
key_id = '1a2bcf49279076a179068a1d1250d68bdc5663e862841241d0b3fa176f6fb6fc'
AND (
token = 'HC2NJBB9svfya6YM72H7I+feRItzU3V+oLTP8LONKRU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)