UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yjGDCZiWaXlaqTPhyzz8gLiBfroIjVSDAWJwk7ktEhc='
WHERE
key_id = '1a7dc0d8f2147cb7f9fdf407adafb99187d86dc84f4946a2d440a75dea281f94'
AND (
token = 'yjGDCZiWaXlaqTPhyzz8gLiBfroIjVSDAWJwk7ktEhc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)