UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SxGyrChsAWcDS8UbkKoxwIzFj46hjR1Nq86nKC9pS4Q='
WHERE
key_id = '8bb4c2b039791118a410d4913c34ff4f42b524c1530acb11cafcc4a7c8884142'
AND (
token = 'SxGyrChsAWcDS8UbkKoxwIzFj46hjR1Nq86nKC9pS4Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)