UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VIziKsivoAmKtkhvX9QE36LtFYk+0kCSw1YdD5hPi5k='
WHERE
key_id = '20dc83e7c95de8c8941e8d3815eed2127c3602c8b2c54a25146de9af76d0f071'
AND (
token = 'VIziKsivoAmKtkhvX9QE36LtFYk+0kCSw1YdD5hPi5k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)