UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3vX+a/49lXuWrIn/HfWHF5Cur686au7m0iuMhIb42X8='
WHERE
key_id = '7f2017132a01ed9b5725b940765a026d9e0573a34614a60be1d66fc87932b0cc'
AND (
token = '3vX+a/49lXuWrIn/HfWHF5Cur686au7m0iuMhIb42X8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)