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